Smartsheet User 99 ✭✭✭

• Activity
• Discussions5
• Comments31

• Re: Birthday/Anniversary Formula & Reminders

  Smartsheet User 99

  04/08/22
  Here is the formula to keep the Date and Month of the Hire, but adding current year to it =DATE(YEAR(TODAY()), MONTH([Company Date of Hire]@row), DAY([Company Date of Hire]@row)) Here is the formula …
  3 ·

• Re: If Formula RGY with numbers greater than, less than and zero

  Smartsheet User 99

  04/08/22
  =IF(ISBLANK([Budget Variance]@row), "", IF([Budget Variance]@row = 0, "Yellow", IF([Budget Variance]@row > 0, "Green", IF([Budget Variance]@row < 0, "Red"…
  1 ·